/*
 Navicat Premium Data Transfer

 Source Server         : 2005
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : mall

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 28/12/2020 16:35:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) DEFAULT NULL,
  `add_time` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `isdel` tinyint(4) DEFAULT NULL,
  `artid` int(11) DEFAULT NULL,
  `rate` int(20) DEFAULT '5',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comments
-- ----------------------------
BEGIN;
INSERT INTO `comments` VALUES (1, '匿名用户', '2018-07-15 14:49:11', '1', 0, 2, NULL);
INSERT INTO `comments` VALUES (2, '匿名用户', '2018-07-15 14:49:13', '2', 0, 2, NULL);
INSERT INTO `comments` VALUES (3, '匿名用户', '2018-07-15 14:49:15', '3', 0, 2, NULL);
INSERT INTO `comments` VALUES (4, '匿名用户', '2018-07-15 14:49:16', '4', 0, 2, NULL);
INSERT INTO `comments` VALUES (5, '匿名用户', '2018-07-15 16:13:48', 'ssss', 0, 12, NULL);
INSERT INTO `comments` VALUES (6, '匿名用户', '2018-07-15 16:13:51', 'ssss', 0, 12, NULL);
INSERT INTO `comments` VALUES (7, '匿名用户', '2018-07-15 16:14:00', '11', 0, 12, NULL);
INSERT INTO `comments` VALUES (8, '匿名用户', '2018-07-15 16:36:55', '沙发沙发沙发沙发沙发沙发', 0, 1, 5);
INSERT INTO `comments` VALUES (9, '匿名用户', '2018-07-15 18:14:19', '锄禾日当午，楼下接上。', 0, 1, 5);
INSERT INTO `comments` VALUES (10, '匿名用户', '2018-07-15 18:14:23', '锄禾是谁', 0, 1, 3);
INSERT INTO `comments` VALUES (11, '匿名用户', '2018-07-15 18:14:24', '当午是谁', 0, 1, 5);
INSERT INTO `comments` VALUES (12, '匿名用户', '2018-07-15 19:35:54', '2222', 0, 1, 5);
INSERT INTO `comments` VALUES (13, '匿名用户', '2018-07-15 19:35:56', 'ddddd', 0, 1, 5);
INSERT INTO `comments` VALUES (14, '匿名用户', '2018-07-15 19:35:59', 'ssss', 0, 1, 3);
INSERT INTO `comments` VALUES (15, '匿名用户', '2019-05-24 00:21:29', '牛逼', 0, 2, NULL);
INSERT INTO `comments` VALUES (16, '匿名用户', '2019-05-24 09:16:25', '牛逼', 0, 1, NULL);
INSERT INTO `comments` VALUES (17, '匿名用户', '2019-08-03 08:51:47', 'sddddd', 0, 7, NULL);
INSERT INTO `comments` VALUES (18, '匿名用户', '2019-08-03 08:51:53', 'dddddd', 0, 7, NULL);
INSERT INTO `comments` VALUES (19, '匿名用户', '2019-11-05 19:30:19', 'dddddd', 0, 1, NULL);
INSERT INTO `comments` VALUES (20, '匿名用户', '2019-11-05 19:30:40', 'ygy', 0, 1, NULL);
INSERT INTO `comments` VALUES (21, '匿名用户', '2019-11-05 19:33:57', 'dfdsfaafagafd', 0, 1, NULL);
INSERT INTO `comments` VALUES (22, '匿名用户', '2019-11-06 09:06:18', 'ddddd', 0, 1, NULL);
INSERT INTO `comments` VALUES (23, '匿名用户', '2019-11-06 09:06:21', 'ssssss', 0, 1, NULL);
INSERT INTO `comments` VALUES (24, '匿名用户', '2019-11-06 09:09:00', 'sssss', 0, 1, NULL);
INSERT INTO `comments` VALUES (25, '匿名用户', '2019-11-06 09:09:37', 'ddssss', 0, 1, NULL);
INSERT INTO `comments` VALUES (29, '匿名用户', '2019-11-06 09:20:14', '', 0, 1, NULL);
INSERT INTO `comments` VALUES (30, '匿名用户', '2020-12-24 16:06:26', '一楼牛逼啊', 0, 1, 0);
INSERT INTO `comments` VALUES (31, '匿名用户', '2020-12-24 16:09:27', '一流的', 0, 1, 0);
INSERT INTO `comments` VALUES (32, '匿名用户', '2020-12-24 16:09:38', 'ssss', 0, 1, 0);
INSERT INTO `comments` VALUES (34, '匿名用户', '2020-12-24 20:52:22', '不足蚂蚁', 0, 3, 5);
INSERT INTO `comments` VALUES (35, '匿名用户', '2020-12-24 21:02:09', 'sf', 0, 1, 5);
INSERT INTO `comments` VALUES (36, '匿名用户', '2020-12-24 21:03:35', '厉害了我的哥', 0, 1, 5);
INSERT INTO `comments` VALUES (37, '匿名用户', '2020-12-24 21:04:40', '厉害了', 0, 3, 5);
INSERT INTO `comments` VALUES (38, '匿名用户', '2020-12-24 21:05:03', '不是吧', 0, 2, 5);
INSERT INTO `comments` VALUES (39, '匿名用户', '2020-12-24 21:06:40', 'ssr', 0, 2, 5);
INSERT INTO `comments` VALUES (40, '匿名用户', '2020-12-24 21:07:02', '999', 0, 2, 5);
INSERT INTO `comments` VALUES (41, '匿名用户', '2020-12-25 09:02:07', 'sf', 0, 3, 5);
INSERT INTO `comments` VALUES (42, '匿名用户', '2020-12-25 09:04:09', '好好说说', 0, 3, 5);
INSERT INTO `comments` VALUES (43, '匿名用户', '2020-12-25 09:38:23', '一楼如此优秀', 0, 3, 5);
INSERT INTO `comments` VALUES (44, '匿名用户', '2020-12-25 09:39:59', '锄禾日当午', 0, 3, 5);
INSERT INTO `comments` VALUES (45, '匿名用户', '2020-12-25 09:43:57', '蚂蚁', 0, 3, 5);
COMMIT;

-- ----------------------------
-- Table structure for girds
-- ----------------------------
DROP TABLE IF EXISTS `girds`;
CREATE TABLE `girds` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `to` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `src` varchar(255) DEFAULT NULL,
  `isdel` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of girds
-- ----------------------------
BEGIN;
INSERT INTO `girds` VALUES (1, '/home/newslist', '新闻资讯', '/home/gird/menu1.png', '0');
INSERT INTO `girds` VALUES (2, '/home/photolist', '图片分享', '/home/gird/menu2.png', '0');
INSERT INTO `girds` VALUES (3, '/home/goodslist', '商品购买', '/home/gird/menu3.png', '0');
INSERT INTO `girds` VALUES (4, '/home/newslist', '留言反馈', '/home/gird/menu4.png', '0');
INSERT INTO `girds` VALUES (5, '/home/newslist', '视频区域', '/home/gird/menu5.png', '0');
INSERT INTO `girds` VALUES (6, '/home/newslist', '联系我们', '/home/gird/menu6.png', '0');
COMMIT;

-- ----------------------------
-- Table structure for good_desc
-- ----------------------------
DROP TABLE IF EXISTS `good_desc`;
CREATE TABLE `good_desc` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `isdel` varchar(255) DEFAULT NULL,
  `desc_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of good_desc
-- ----------------------------
BEGIN;
INSERT INTO `good_desc` VALUES (0, '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '限时下单立减100，到手价2499元，赠荣耀耳机+运动臂带，享双倍积分，晒单赢499元美食卡，现货速发！', '0', 101);
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `add_time` datetime DEFAULT NULL,
  `zhaiyao` varchar(255) DEFAULT NULL,
  `click` varchar(255) DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `sell_price` decimal(10,0) DEFAULT NULL,
  `market_price` decimal(10,0) DEFAULT NULL,
  `stock_quantity` varchar(255) DEFAULT NULL,
  `isdel` tinyint(4) DEFAULT NULL,
  `thumb_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` VALUES (101, '荣耀10', '2018-07-15 19:14:00', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 101);
INSERT INTO `goods` VALUES (102, 'HUAWEI P20', '2018-07-15 19:14:00', 'HUAWEI P20 6GB+64GB 全网通版（极光色）', '3000', '/goods/images/2.jpg', 3788, 4000, '10', 0, 102);
INSERT INTO `goods` VALUES (103, '荣耀V10', '2018-07-15 19:14:00', '荣耀V10 全网通标配版 4GB+64GB（魅丽红）', '100', '/goods/images/3.jpg', 1999, 2200, '100', 0, 103);
INSERT INTO `goods` VALUES (104, '荣耀10 ', '2018-07-15 19:26:27', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 104);
INSERT INTO `goods` VALUES (105, '荣耀10 ', '2018-07-15 19:33:13', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 105);
INSERT INTO `goods` VALUES (106, '荣耀10 ', '2018-07-15 19:33:14', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 106);
INSERT INTO `goods` VALUES (107, '荣耀10 ', '2018-07-15 19:33:15', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 107);
INSERT INTO `goods` VALUES (108, '荣耀10 ', '2018-07-15 19:33:15', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 108);
INSERT INTO `goods` VALUES (109, '荣耀10 ', '2018-07-15 19:33:16', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 109);
INSERT INTO `goods` VALUES (110, '荣耀10 ', '2018-07-15 19:33:16', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 110);
INSERT INTO `goods` VALUES (111, '荣耀10 ', '2018-07-15 19:33:16', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 110);
INSERT INTO `goods` VALUES (112, '荣耀10 ', '2018-07-15 19:33:16', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 110);
INSERT INTO `goods` VALUES (113, '荣耀10 ', '2018-07-15 19:33:16', '荣耀10 AI摄影手机 6GB+64GB 幻影蓝 全网通 双卡双待 高配版 荣耀 10GT', '299', '/goods/images/1.jpg', 2599, 3000, '60', 0, 110);
COMMIT;

-- ----------------------------
-- Table structure for goods_info
-- ----------------------------
DROP TABLE IF EXISTS `goods_info`;
CREATE TABLE `goods_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `add_time` datetime DEFAULT NULL,
  `sell_price` decimal(10,0) DEFAULT NULL,
  `market_price` decimal(10,0) DEFAULT NULL,
  `stock_quantity` varchar(255) DEFAULT NULL,
  `isdel` tinyint(4) DEFAULT NULL,
  `goods_no` varchar(255) DEFAULT NULL,
  `goods_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods_info
-- ----------------------------
BEGIN;
INSERT INTO `goods_info` VALUES (1, '荣耀10', '2018-07-15 19:14:00', 2599, 3000, '60', 0, 'SD3345678902', 101);
INSERT INTO `goods_info` VALUES (2, 'HUAWEI P20', '2018-07-15 19:14:00', 3788, 4000, '10', 0, 'SD3345678902', 102);
INSERT INTO `goods_info` VALUES (3, '荣耀V10', '2018-07-15 19:14:00', 1999, 2200, '100', 0, 'SD3345678902', 103);
INSERT INTO `goods_info` VALUES (4, '荣耀10 ', '2018-07-15 19:26:27', 2599, 3000, '60', 0, 'SD3345678902', 4);
INSERT INTO `goods_info` VALUES (5, '荣耀10 ', '2018-07-15 19:33:13', 2599, 3000, '60', 0, 'SD3345678902', 5);
INSERT INTO `goods_info` VALUES (6, '荣耀10 ', '2018-07-15 19:33:14', 2599, 3000, '60', 0, 'SD3345678902', 6);
INSERT INTO `goods_info` VALUES (7, '荣耀10 ', '2018-07-15 19:33:15', 2599, 3000, '60', 0, 'SD3345678902', 7);
INSERT INTO `goods_info` VALUES (8, '荣耀10 ', '2018-07-15 19:33:15', 2599, 3000, '60', 0, 'SD3345678902', 8);
INSERT INTO `goods_info` VALUES (9, '荣耀10 ', '2018-07-15 19:33:16', 2599, 3000, '60', 0, 'SD3345678902', 9);
INSERT INTO `goods_info` VALUES (10, '荣耀10 ', '2018-07-15 19:33:16', 2599, 3000, '60', 0, 'SD3345678902', 10);
COMMIT;

-- ----------------------------
-- Table structure for imgs_class
-- ----------------------------
DROP TABLE IF EXISTS `imgs_class`;
CREATE TABLE `imgs_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `isdel` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of imgs_class
-- ----------------------------
BEGIN;
INSERT INTO `imgs_class` VALUES (1, '美女', '0');
INSERT INTO `imgs_class` VALUES (2, '宠物', '0');
INSERT INTO `imgs_class` VALUES (3, '家具', '0');
INSERT INTO `imgs_class` VALUES (4, '运动', '0');
INSERT INTO `imgs_class` VALUES (5, '数码', '0');
INSERT INTO `imgs_class` VALUES (6, '乐器', '0');
INSERT INTO `imgs_class` VALUES (7, '游戏', '0');
COMMIT;

-- ----------------------------
-- Table structure for imgs_data
-- ----------------------------
DROP TABLE IF EXISTS `imgs_data`;
CREATE TABLE `imgs_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `zhaiyao` varchar(255) DEFAULT NULL,
  `isdel` tinyint(4) DEFAULT NULL,
  `class_id` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of imgs_data
-- ----------------------------
BEGIN;
INSERT INTO `imgs_data` VALUES (1, '教师节快乐', '/share/images/1.jpg', '好好学习，天天向上', 0, 1);
INSERT INTO `imgs_data` VALUES (2, '教师节快乐', '/share/images/2.jpg', '好好学习，天天向上', 0, 1);
INSERT INTO `imgs_data` VALUES (3, '教师节快乐', '/share/images/3.jpg', '好好学习，天天向上', 0, 1);
INSERT INTO `imgs_data` VALUES (4, '教师节快乐', '/share/images/4.jpg', '好好学习，天天向上', 0, 1);
INSERT INTO `imgs_data` VALUES (5, '教师节快乐', '/share/images/5.jpg', '好好学习，天天向上', 0, 1);
INSERT INTO `imgs_data` VALUES (6, '教师节快乐', '/share/images/6.jpg', '好好学习，天天向上', 0, 1);
INSERT INTO `imgs_data` VALUES (7, '教师节快乐', '/share/images/7.jpg', '好好学习，天天向上', 0, 2);
INSERT INTO `imgs_data` VALUES (8, '教师节快乐', '/share/images/8.jpg', '好好学习，天天向上', 0, 2);
INSERT INTO `imgs_data` VALUES (9, '教师节快乐', '/share/images/9.jpg', '好好学习，天天向上', 0, 2);
INSERT INTO `imgs_data` VALUES (10, '教师节快乐', '/share/images/10.jpg', '好好学习，天天向上', 0, 2);
INSERT INTO `imgs_data` VALUES (11, '教师节快乐', '/share/images/11.jpg', '好好学习，天天向上', 0, 2);
INSERT INTO `imgs_data` VALUES (12, '教师节快乐', '/share/images/12.jpg', '好好学习，天天向上', 0, 2);
INSERT INTO `imgs_data` VALUES (13, '教师节快乐', '/share/images/13.jpg', '好好学习，天天向上', 0, 3);
INSERT INTO `imgs_data` VALUES (14, '教师节快乐', 'http://localhost:5000/share/images/14.jpg', '好好学习，天天向上', 0, 3);
COMMIT;

-- ----------------------------
-- Table structure for imgs_info
-- ----------------------------
DROP TABLE IF EXISTS `imgs_info`;
CREATE TABLE `imgs_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `click` varchar(255) DEFAULT NULL,
  `add_time` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `isdel` tinyint(255) DEFAULT NULL,
  `info_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of imgs_info
-- ----------------------------
BEGIN;
INSERT INTO `imgs_info` VALUES (1, '教师节快乐', '3', '2018-07-10 15:53:46', '难忘的校园时光，有着难忘的师生情怀；坦诚的学生时代，有着您孜孜不倦的...', 0, 2);
INSERT INTO `imgs_info` VALUES (2, '教师节快乐', '3', '2018-07-10 15:53:46', '难忘的校园时光，有着难忘的师生情怀；坦诚的学生时代，有着您孜孜不倦的...', 0, 1);
INSERT INTO `imgs_info` VALUES (3, '教师节快乐', '3', '2018-07-10 15:53:46', '难忘的校园时光，有着难忘的师生情怀；坦诚的学生时代，有着您孜孜不倦的...', 0, 3);
COMMIT;

-- ----------------------------
-- Table structure for imgs_thumbs
-- ----------------------------
DROP TABLE IF EXISTS `imgs_thumbs`;
CREATE TABLE `imgs_thumbs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `src` varchar(255) DEFAULT NULL,
  `isdel` varchar(255) DEFAULT NULL,
  `thumbs_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of imgs_thumbs
-- ----------------------------
BEGIN;
INSERT INTO `imgs_thumbs` VALUES (1, '/share/images/1.jpg', '0', 1);
INSERT INTO `imgs_thumbs` VALUES (2, '/share/images/2.jpg', '0', 1);
INSERT INTO `imgs_thumbs` VALUES (3, '/share/images/3.jpg', '0', 1);
INSERT INTO `imgs_thumbs` VALUES (4, '/share/images/4.jpg', '0', 2);
INSERT INTO `imgs_thumbs` VALUES (5, '/share/images/5.jpg', '0', 2);
INSERT INTO `imgs_thumbs` VALUES (6, '/share/images/6.jpg', '0', 2);
INSERT INTO `imgs_thumbs` VALUES (7, '/share/ithumbs/images/5.jpg', '0', 101);
INSERT INTO `imgs_thumbs` VALUES (8, '/share/ithumbs/images/6.jpg', '0', 101);
INSERT INTO `imgs_thumbs` VALUES (9, '/share/ithumbs/images/7.jpg', '1', 1011);
INSERT INTO `imgs_thumbs` VALUES (10, '/share/ithumbs/images/8.jpg', '0', 102);
INSERT INTO `imgs_thumbs` VALUES (11, '/share/ithumbs/images/9.jpg', '0', 102);
INSERT INTO `imgs_thumbs` VALUES (12, '/share/ithumbs/images/10.jpg', '0', 102);
INSERT INTO `imgs_thumbs` VALUES (13, '/share/ithumbs/images/11.jpg', '0', 103);
INSERT INTO `imgs_thumbs` VALUES (14, '/share/ithumbs/images/12.jpg', '0', 103);
INSERT INTO `imgs_thumbs` VALUES (15, '/share/ithumbs/images/13.jpg', '0', 103);
COMMIT;

-- ----------------------------
-- Table structure for lunbo
-- ----------------------------
DROP TABLE IF EXISTS `lunbo`;
CREATE TABLE `lunbo` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `img` varchar(255) DEFAULT NULL,
  `isdel` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lunbo
-- ----------------------------
BEGIN;
INSERT INTO `lunbo` VALUES (1, '/home/lunbo/1.jpg', '0');
INSERT INTO `lunbo` VALUES (2, '/home/lunbo/2.jpg', '0');
INSERT INTO `lunbo` VALUES (3, '/home/lunbo/3.jpg', '0');
COMMIT;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `add_time` varchar(255) DEFAULT NULL,
  `zhaiyao` varchar(255) DEFAULT NULL,
  `click` varchar(255) DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `isdel` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of news
-- ----------------------------
BEGIN;
INSERT INTO `news` VALUES (1, '《宝可梦：超梦的逆袭 进化》将于12月4日登陆内地院线', '2018-07-10 15:53:46', '《宝可梦：超梦的逆袭 进化》', '1', '/news/images/1.jpg', '《宝可梦：超梦的逆袭 进化》将于12月4日登陆内地院线，今日片方发布一组全新的角色海报。', 0);
INSERT INTO `news` VALUES (2, '梁朝伟搭档段奕宏的电影《猎狐行动》将于2021年1月8日全国上映', '2018-07-10 15:53:47', '《猎狐行动》', '1', '/news/images/2.jpg', '梁朝伟在片中饰演“红通”经济犯罪嫌疑人戴逸宸，为了权钱利益不择手段，被日益膨胀的欲望拉入深渊，而段奕宏饰演的经侦民警“苦追”戴逸宸七年，期间经历种种危难都毫不退缩。', 0);
INSERT INTO `news` VALUES (3, '不足百字蚂蚁二次约谈消息稿释放三个强烈信号', '2018-07-10 15:53:48', '不足百字蚂蚁二次约谈', '1', '/news/images/3.jpg', '中国人民银行、中国银保监会、中国证监会、国家外汇管理局将于近日约谈蚂蚁集团，督促指导蚂蚁集团按照市场化、法治化原则，落实金融监管、公平竞争和保护消费者合法权益等要求，规范金融业务经营与发展。', 0);
COMMIT;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `ctime` varchar(255) DEFAULT NULL,
  `isdel` tinyint(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES (1, '奥迪', '2018-07-10 14:01:12', 0);
INSERT INTO `product` VALUES (2, '宝马', '2018-07-10 14:01:19', 0);
INSERT INTO `product` VALUES (3, '大众', '2018-07-10 14:01:43', 0);
INSERT INTO `product` VALUES (4, '宝马x5', '2019-10-29 10:33:24', 0);
INSERT INTO `product` VALUES (5, '宝马xxx', '2019-10-29 10:46:22', 1);
INSERT INTO `product` VALUES (6, '五菱宏光', '2019-10-29 11:22:51', 0);
INSERT INTO `product` VALUES (7, '特斯拉', '2019-10-29 11:23:24', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
